package com.ftg.shopping.memberlogin.mapper;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ftg.shopping.member.entity.sp_memberinfo;
import lombok.Data;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.Base64;
import java.util.Map;

@Mapper
public interface MemberLoginMapper extends BaseMapper<sp_memberinfo> {


@Insert("insert into sp_memberinfo(userid,username,password,tel) values (#{userid},#{username},#{password},#{tel})")
int insert(sp_memberinfo m);

    @Select("select *from sp_memberinfo where userid=#{userid}")
    Map<String,Object> showmember(sp_memberinfo m);
}
